| blockAcala | blockKarura | Date | aUSD_Karura | aUSD_Acala | aUSD_Total |
|---|---|---|---|---|---|
| 382,658 | 1,498,135 | 2022-02-10 | 5,767,842 | 1,828,453 | 7,596,295 |
| 389,478 | 1,502,412 | 2022-02-11 | 5,650,252 | 2,717,049 | 8,367,301 |
| 396,298 | 1,506,675 | 2022-02-12 | 5,646,145 | 2,936,480 | 8,582,624 |
| 403,080 | 1,510,965 | 2022-02-13 | 5,856,542 | 2,983,693 | 8,840,235 |
| 409,851 | 1,515,339 | 2022-02-14 | 5,841,993 | 3,035,791 | 8,877,784 |
| 416,618 | 1,519,779 | 2022-02-15 | 5,860,838 | 3,737,926 | 9,598,764 |
| 423,364 | 1,524,208 | 2022-02-16 | 5,821,150 | 4,175,472 | 9,996,623 |
| 429,431 | 1,528,534 | 2022-02-17 | 5,721,577 | 4,597,237 | 10,318,814 |
| 435,379 | 1,532,831 | 2022-02-18 | 5,648,546 | 4,686,985 | 10,335,531 |
| 441,244 | 1,537,082 | 2022-02-19 | 5,553,868 | 4,817,623 | 10,371,492 |
| 447,046 | 1,541,290 | 2022-02-20 | 5,281,255 | 5,250,047 | 10,531,302 |
| 452,805 | 1,545,293 | 2022-02-21 | 5,215,281 | 5,577,267 | 10,792,548 |
| 458,591 | 1,549,212 | 2022-02-22 | 5,018,519 | 5,290,149 | 10,308,668 |
| 464,375 | 1,553,133 | 2022-02-23 | 4,970,303 | 5,276,073 | 10,246,375 |
| 470,299 | 1,557,141 | 2022-02-24 | 4,643,933 | 4,943,368 | 9,587,301 |
| 476,519 | 1,561,208 | 2022-02-25 | 4,675,561 | 4,978,260 | 9,653,820 |
| 483,026 | 1,565,186 | 2022-02-26 | 4,676,162 | 5,039,742 | 9,715,904 |
| 489,670 | 1,569,198 | 2022-02-27 | 4,627,923 | 5,069,752 | 9,697,675 |
| 496,214 | 1,573,192 | 2022-02-28 | 4,673,425 | 5,143,742 | 9,817,167 |
| 502,741 | 1,577,360 | 2022-03-01 | 4,728,346 | 5,195,708 | 9,924,053 |
| 509,328 | 1,581,658 | 2022-03-02 | 4,750,544 | 5,270,660 | 10,021,204 |
| 515,915 | 1,586,008 | 2022-03-03 | 4,682,114 | 6,025,456 | 10,707,570 |
| 522,577 | 1,590,339 | 2022-03-04 | 4,617,155 | 5,964,756 | 10,581,911 |
| 529,288 | 1,594,558 | 2022-03-05 | 4,588,524 | 5,990,488 | 10,579,012 |
| 535,942 | 1,598,920 | 2022-03-06 | 4,592,027 | 6,003,125 | 10,595,152 |
| 542,760 | 1,603,233 | 2022-03-07 | 4,572,082 | 6,171,523 | 10,743,606 |
| 549,653 | 1,607,573 | 2022-03-08 | 4,570,846 | 6,173,255 | 10,744,100 |
| 556,567 | 1,611,910 | 2022-03-09 | 4,671,687 | 6,207,245 | 10,878,932 |
| 563,674 | 1,616,357 | 2022-03-10 | 4,568,758 | 6,239,169 | 10,807,927 |
| 570,668 | 1,620,876 | 2022-03-11 | 4,579,459 | 6,399,362 | 10,978,821 |
| 577,693 | 1,625,432 | 2022-03-12 | 4,581,608 | 6,451,874 | 11,033,483 |
| 584,752 | 1,629,884 | 2022-03-13 | 4,537,367 | 6,462,624 | 10,999,991 |
| 591,860 | 1,634,405 | 2022-03-14 | 4,504,974 | 6,555,472 | 11,060,446 |
| 598,871 | 1,638,930 | 2022-03-15 | 4,517,668 | 6,576,152 | 11,093,820 |
| 605,882 | 1,643,457 | 2022-03-16 | 4,550,885 | 6,662,331 | 11,213,216 |
| 612,917 | 1,647,983 | 2022-03-17 | 4,590,944 | 6,739,440 | 11,330,384 |
| 620,006 | 1,652,652 | 2022-03-18 | 4,675,263 | 6,813,161 | 11,488,424 |
| 627,056 | 1,657,396 | 2022-03-19 | 4,724,276 | 6,816,139 | 11,540,415 |
| 634,100 | 1,662,219 | 2022-03-20 | 4,750,389 | 6,824,157 | 11,574,546 |
| 641,175 | 1,666,997 | 2022-03-21 | 4,805,186 | 6,895,101 | 11,700,287 |
| 648,244 | 1,671,509 | 2022-03-22 | 4,827,630 | 7,026,981 | 11,854,611 |
| 655,070 | 1,675,850 | 2022-03-23 | 4,865,881 | 6,974,154 | 11,840,035 |
| 661,932 | 1,680,082 | 2022-03-24 | 4,857,238 | 7,027,391 | 11,884,629 |
| 668,922 | 1,684,322 | 2022-03-25 | 4,869,007 | 7,144,140 | 12,013,147 |
| 675,883 | 1,688,574 | 2022-03-26 | 4,849,235 | 7,238,112 | 12,087,347 |
| 682,919 | 1,692,713 | 2022-03-27 | 4,895,435 | 7,492,344 | 12,387,779 |
| 689,974 | 1,696,873 | 2022-03-28 | 4,930,751 | 7,605,614 | 12,536,365 |
| 697,050 | 1,700,908 | 2022-03-29 | 5,067,601 | 7,741,578 | 12,809,179 |
| 704,068 | 1,704,922 | 2022-03-30 | 5,130,914 | 7,818,922 | 12,949,836 |
| 711,104 | 1,708,906 | 2022-03-31 | 5,239,132 | 7,864,343 | 13,103,475 |
| 718,140 | 1,712,970 | 2022-04-01 | 5,202,627 | 6,582,120 | 11,784,747 |
| 725,135 | 1,717,078 | 2022-04-02 | 5,278,899 | 6,826,597 | 12,105,496 |
| 732,169 | 1,721,276 | 2022-04-03 | 5,282,403 | 6,843,151 | 12,125,554 |
| 739,232 | 1,725,277 | 2022-04-04 | 5,155,766 | 6,900,641 | 12,056,407 |
| 746,312 | 1,729,249 | 2022-04-05 | 5,172,532 | 6,964,965 | 12,137,497 |
| 753,339 | 1,733,105 | 2022-04-06 | 5,083,636 | 6,850,470 | 11,934,106 |
| 760,400 | 1,736,920 | 2022-04-07 | 5,356,936 | 6,933,225 | 12,290,161 |
| 767,454 | 1,740,728 | 2022-04-08 | 5,333,274 | 7,042,668 | 12,375,942 |
| 774,447 | 1,744,511 | 2022-04-09 | 5,305,469 | 7,217,070 | 12,522,539 |
| 781,545 | 1,748,342 | 2022-04-10 | 5,351,529 | 7,218,353 | 12,569,882 |
| 788,553 | 1,752,148 | 2022-04-11 | 5,148,440 | 7,222,597 | 12,371,037 |
| 795,620 | 1,756,009 | 2022-04-12 | 5,168,805 | 7,265,808 | 12,434,614 |
| 802,608 | 1,759,810 | 2022-04-13 | 5,166,177 | 7,391,025 | 12,557,203 |
| 809,644 | 1,763,619 | 2022-04-14 | 5,181,003 | 7,582,148 | 12,763,152 |
| 816,668 | 1,767,375 | 2022-04-15 | 5,225,609 | 7,632,200 | 12,857,809 |
| 823,732 | 1,771,087 | 2022-04-16 | 5,231,498 | 7,625,873 | 12,857,371 |
| 830,766 | 1,774,902 | 2022-04-17 | 5,221,374 | 7,662,176 | 12,883,549 |
| 837,826 | 1,778,708 | 2022-04-18 | 5,204,413 | 7,690,803 | 12,895,216 |
| 844,870 | 1,782,472 | 2022-04-19 | 5,197,599 | 7,797,376 | 12,994,975 |
| 851,796 | 1,786,343 | 2022-04-20 | 5,234,624 | 7,782,928 | 13,017,552 |
| 858,830 | 1,790,294 | 2022-04-21 | 5,315,784 | 7,720,130 | 13,035,914 |
| 865,842 | 1,794,197 | 2022-04-22 | 5,277,628 | 7,795,274 | 13,072,902 |
| 872,830 | 1,798,162 | 2022-04-23 | 5,548,256 | 7,784,345 | 13,332,601 |
| 879,807 | 1,802,115 | 2022-04-24 | 5,465,898 | 7,748,606 | 13,214,504 |
| 886,715 | 1,806,087 | 2022-04-25 | 5,464,495 | 7,708,251 | 13,172,746 |
| 893,713 | 1,810,046 | 2022-04-26 | 5,443,354 | 7,676,992 | 13,120,346 |
| 900,680 | 1,814,021 | 2022-04-27 | 5,414,557 | 7,698,776 | 13,113,334 |
| 907,463 | 1,817,974 | 2022-04-28 | 5,417,024 | 7,711,733 | 13,128,757 |
| 914,420 | 1,821,980 | 2022-04-29 | 5,401,302 | 7,646,778 | 13,048,079 |
| 921,375 | 1,826,039 | 2022-04-30 | 5,325,695 | 7,363,469 | 12,689,164 |
| 928,262 | 1,830,125 | 2022-05-01 | 5,308,806 | 7,296,870 | 12,605,676 |
| 935,210 | 1,834,044 | 2022-05-02 | 5,290,063 | 7,305,066 | 12,595,129 |
| 941,991 | 1,837,991 | 2022-05-03 | 5,289,398 | 7,326,266 | 12,615,664 |
| 948,773 | 1,841,986 | 2022-05-04 | 5,297,538 | 7,377,038 | 12,674,576 |
| 955,553 | 1,846,132 | 2022-05-05 | 5,283,745 | 7,300,340 | 12,584,084 |
| 962,314 | 1,850,190 | 2022-05-06 | 5,288,666 | 7,277,406 | 12,566,072 |
| 969,145 | 1,854,421 | 2022-05-07 | 5,234,538 | 9,743,345 | 14,977,883 |
| 975,941 | 1,858,658 | 2022-05-08 | 5,049,196 | 9,491,303 | 14,540,499 |
| 982,741 | 1,862,992 | 2022-05-09 | 4,856,056 | 8,582,048 | 13,438,104 |
| 989,571 | 1,867,957 | 2022-05-10 | 4,445,392 | 8,719,668 | 13,165,060 |
| 996,410 | 1,873,972 | 2022-05-11 | 3,975,273 | 6,972,738 | 10,948,011 |
| 1,003,195 | 1,880,188 | 2022-05-12 | 3,790,518 | 5,623,934 | 9,414,452 |
| 1,010,207 | 1,886,554 | 2022-05-13 | 3,828,842 | 5,803,385 | 9,632,227 |
| 1,017,179 | 1,892,961 | 2022-05-14 | 3,812,935 | 5,818,547 | 9,631,483 |
| 1,024,222 | 1,899,371 | 2022-05-15 | 3,856,292 | 5,927,092 | 9,783,384 |
| 1,031,247 | 1,905,778 | 2022-05-16 | 3,925,850 | 5,952,977 | 9,878,827 |
| 1,038,263 | 1,912,230 | 2022-05-17 | 3,977,072 | 6,008,718 | 9,985,790 |
| 1,044,985 | 1,918,591 | 2022-05-18 | 3,942,409 | 5,996,488 | 9,938,898 |
| 1,051,890 | 1,924,950 | 2022-05-19 | 3,999,092 | 5,979,944 | 9,979,036 |
| 1,058,796 | 1,931,289 | 2022-05-20 | 3,997,746 | 5,973,335 | 9,971,081 |
| 1,065,696 | 1,937,640 | 2022-05-21 | 4,028,271 | 5,991,504 | 10,019,775 |
| 1,072,674 | 1,944,002 | 2022-05-22 | 4,053,215 | 6,016,222 | 10,069,437 |
| 1,079,644 | 1,950,438 | 2022-05-23 | 4,092,102 | 6,049,078 | 10,141,180 |
| 1,086,605 | 1,956,833 | 2022-05-24 | 4,104,772 | 6,095,595 | 10,200,367 |
| 1,093,548 | 1,963,028 | 2022-05-25 | 4,100,411 | 6,116,611 | 10,217,022 |
| 1,100,467 | 1,969,604 | 2022-05-26 | 4,072,206 | 6,058,377 | 10,130,583 |
| 1,107,371 | 1,975,998 | 2022-05-27 | 4,055,514 | 6,022,962 | 10,078,476 |
| 1,114,253 | 1,982,535 | 2022-05-28 | 4,063,472 | 6,057,937 | 10,121,410 |
| 1,121,139 | 1,988,972 | 2022-05-29 | 4,065,723 | 6,081,219 | 10,146,942 |
| 1,128,033 | 1,995,443 | 2022-05-30 | 4,075,179 | 6,121,133 | 10,196,312 |
| 1,134,939 | 2,001,782 | 2022-05-31 | 4,196,753 | 6,132,025 | 10,328,778 |
| 1,141,677 | 2,008,273 | 2022-06-01 | 4,184,512 | 6,138,539 | 10,323,051 |
| 1,148,531 | 2,014,698 | 2022-06-02 | 4,192,668 | 6,208,705 | 10,401,373 |
| 1,155,361 | 2,021,059 | 2022-06-03 | 4,151,279 | 6,161,418 | 10,312,697 |
| 1,162,191 | 2,027,513 | 2022-06-04 | 4,154,170 | 6,110,974 | 10,265,145 |
| 1,168,945 | 2,034,053 | 2022-06-05 | 4,166,220 | 6,123,639 | 10,289,859 |
| 1,175,760 | 2,040,490 | 2022-06-06 | 4,179,423 | 6,143,116 | 10,322,540 |
| 1,182,503 | 2,046,816 | 2022-06-07 | 4,177,516 | 6,141,992 | 10,319,507 |
| 1,189,273 | 2,053,305 | 2022-06-08 | 4,178,977 | 6,137,929 | 10,316,907 |
| 1,196,022 | 2,059,744 | 2022-06-09 | 4,177,130 | 6,170,211 | 10,347,341 |
| 1,202,808 | 2,066,092 | 2022-06-10 | 4,149,014 | 6,136,321 | 10,285,335 |
| 1,209,560 | 2,072,325 | 2022-06-11 | 4,102,379 | 6,074,914 | 10,177,292 |
| 1,216,309 | 2,078,699 | 2022-06-12 | 4,004,056 | 5,891,343 | 9,895,398 |
| 1,222,967 | 2,084,974 | 2022-06-13 | 3,729,152 | 5,577,153 | 9,306,304 |
| 1,229,621 | 2,091,245 | 2022-06-14 | 3,735,276 | 5,568,632 | 9,303,909 |
| 1,236,320 | 2,097,549 | 2022-06-15 | 3,788,931 | 5,315,691 | 9,104,622 |
| 1,242,989 | 2,103,874 | 2022-06-16 | 3,784,345 | 5,287,516 | 9,071,861 |
| 1,249,647 | 2,110,292 | 2022-06-17 | 3,780,450 | 5,278,713 | 9,059,163 |
| 1,256,310 | 2,116,724 | 2022-06-18 | 3,744,797 | 5,247,145 | 8,991,943 |
| 1,263,003 | 2,123,104 | 2022-06-19 | 3,770,456 | 5,272,379 | 9,042,835 |
| 1,269,614 | 2,129,497 | 2022-06-20 | 3,773,566 | 4,741,005 | 8,514,571 |
| 1,276,376 | 2,135,922 | 2022-06-21 | 3,819,698 | 4,369,718 | 8,189,416 |
| 1,283,096 | 2,142,278 | 2022-06-22 | 3,827,112 | 4,370,810 | 8,197,922 |
| 1,289,783 | 2,148,575 | 2022-06-23 | 3,829,884 | 4,383,622 | 8,213,505 |
| 1,296,569 | 2,155,139 | 2022-06-24 | 3,832,776 | 4,397,323 | 8,230,099 |
| 1,303,311 | 2,161,562 | 2022-06-25 | 3,852,269 | 4,383,177 | 8,235,446 |
| 1,310,012 | 2,168,013 | 2022-06-26 | 3,876,004 | 4,374,412 | 8,250,416 |
| 1,316,693 | 2,173,904 | 2022-06-27 | 3,839,320 | 4,375,858 | 8,215,178 |
| 1,323,587 | 2,179,759 | 2022-06-28 | 3,806,037 | 4,373,729 | 8,179,766 |
| 1,330,303 | 2,185,605 | 2022-06-29 | 3,806,447 | 4,356,996 | 8,163,443 |
| 1,337,106 | 2,191,479 | 2022-06-30 | 3,774,174 | 4,331,462 | 8,105,636 |
| 1,343,825 | 2,197,147 | 2022-07-01 | 3,780,968 | 4,341,066 | 8,122,034 |
| 1,350,568 | 2,202,851 | 2022-07-02 | 3,806,688 | 4,354,300 | 8,160,989 |
| 1,357,347 | 2,208,544 | 2022-07-03 | 3,808,055 | 4,364,355 | 8,172,409 |
| 1,364,102 | 2,214,453 | 2022-07-04 | 3,812,428 | 4,372,827 | 8,185,255 |
| 1,370,943 | 2,220,335 | 2022-07-05 | 3,814,667 | 4,361,714 | 8,176,381 |
| 1,377,797 | 2,226,215 | 2022-07-06 | 3,815,652 | 4,364,384 | 8,180,036 |
| 1,384,635 | 2,232,059 | 2022-07-07 | 3,828,444 | 4,348,406 | 8,176,850 |
| 1,391,485 | 2,237,967 | 2022-07-08 | 3,837,918 | 4,347,524 | 8,185,442 |
| 1,398,299 | 2,243,857 | 2022-07-09 | 3,838,538 | 4,359,566 | 8,198,105 |
| 1,405,185 | 2,249,769 | 2022-07-10 | 3,840,756 | 4,352,234 | 8,192,990 |
| 1,411,909 | 2,255,713 | 2022-07-11 | 4,109,701 | 4,392,931 | 8,502,632 |
| 1,418,742 | 2,261,599 | 2022-07-12 | 4,107,944 | 4,358,631 | 8,466,575 |
| 1,425,585 | 2,267,294 | 2022-07-13 | 4,111,157 | 4,375,114 | 8,486,271 |
| 1,432,337 | 2,273,077 | 2022-07-14 | 4,111,947 | 4,374,531 | 8,486,478 |
| 1,439,201 | 2,278,953 | 2022-07-15 | 4,116,349 | 4,358,426 | 8,474,775 |
| 1,446,008 | 2,284,856 | 2022-07-16 | 4,116,661 | 4,348,617 | 8,465,278 |
| 1,452,960 | 2,290,692 | 2022-07-17 | 4,103,475 | 4,358,982 | 8,462,457 |
| 1,459,795 | 2,296,494 | 2022-07-18 | 4,111,415 | 4,398,737 | 8,510,151 |
| 1,466,580 | 2,302,426 | 2022-07-19 | 4,120,933 | 4,454,538 | 8,575,471 |
| 1,473,380 | 2,308,357 | 2022-07-20 | 4,126,611 | 4,500,049 | 8,626,660 |
| 1,480,245 | 2,314,283 | 2022-07-21 | 4,135,964 | 4,499,787 | 8,635,751 |
| 1,487,055 | 2,320,158 | 2022-07-22 | 4,227,100 | 4,533,147 | 8,760,248 |
| 1,493,873 | 2,326,054 | 2022-07-23 | 4,262,965 | 4,597,204 | 8,860,169 |
| 1,500,756 | 2,332,160 | 2022-07-24 | 4,266,207 | 4,605,889 | 8,872,096 |
| 1,507,666 | 2,338,259 | 2022-07-25 | 4,265,334 | 4,580,132 | 8,845,466 |
| 1,514,538 | 2,344,082 | 2022-07-26 | 4,193,132 | 4,577,767 | 8,770,899 |
| 1,521,363 | 2,349,718 | 2022-07-27 | 4,212,560 | 4,613,498 | 8,826,057 |
| 1,528,147 | 2,355,349 | 2022-07-28 | 4,216,008 | 4,623,185 | 8,839,193 |
| 1,535,018 | 2,360,978 | 2022-07-29 | 4,222,698 | 4,634,895 | 8,857,593 |
| 1,541,851 | 2,366,635 | 2022-07-30 | 4,258,459 | 4,640,917 | 8,899,376 |
| 1,548,704 | 2,372,202 | 2022-07-31 | 4,262,927 | 4,660,909 | 8,923,837 |
| 1,555,507 | 2,377,806 | 2022-08-01 | 4,267,948 | 5,783,151 | 10,051,099 |
| 1,562,419 | 2,383,360 | 2022-08-02 | 4,717,685 | 5,761,618 | 10,479,303 |
| 1,569,336 | 2,388,999 | 2022-08-03 | 4,720,206 | 5,756,487 | 10,476,693 |
| 1,576,157 | 2,394,583 | 2022-08-04 | 4,709,731 | 5,800,920 | 10,510,651 |
| 1,583,026 | 2,400,226 | 2022-08-05 | 4,719,403 | 5,854,369 | 10,573,772 |
| 1,589,971 | 2,406,084 | 2022-08-06 | 4,723,547 | 5,925,218 | 10,648,764 |
| 1,596,911 | 2,411,957 | 2022-08-07 | 4,723,069 | 5,941,852 | 10,664,921 |
| 1,603,908 | 2,417,831 | 2022-08-08 | 4,752,236 | 6,012,468 | 10,764,704 |
| 1,604,179 | 2,418,115 | 2022-08-09 | 4,754,006 | 6,004,769 | 10,758,775 |
Please click on the Source Code link at the top of the document to see the full source code. Here is a summary:
---
title: "Acala / Karura aUSD Dashboard"
output:
flexdashboard::flex_dashboard:
orientation: rows
vertical_layout: scroll
social: menu
source_code: embed
---
```{css custom1, echo=FALSE}
.dataTables_scrollBody {
max-height: 100% !important;
}
```
```{r global, include=FALSE}
library(knitr)
knitr::opts_chunk$set(
message = FALSE,
warning = FALSE,
comment = "#>"
)
library(ggplot2)
# library(dygraphs)
library(kableExtra)
library(formattable)
library(lubridate)
library(flexdashboard)
library(DT)
library(subscanr)
library(formattable)
library(ghql)
x <- GraphqlClient$new()
# Helper function to concat
`%+%` <- function(a, b) paste0(a, b)
window <- today() - as.Date("2021-12-31") + 1
# Liquidity Pool TVL ($3.72M) = totalDefiTvl = totalDexTvl + totalDexLockedTvl + homaLocked + stableCoinTvl
kdex <- getDailyPools_acala_dex("karura", window) %>%
setorder(Date, pair)
adex <- getDailyPools_acala_dex("acala", window) %>%
setorder(Date, pair)
adaily <- adex[, max(updateAtBlock.id), by = Date] %>%
setnames("V1", "blockAcala")
kdaily <- kdex[, max(updateAtBlock.id), by = Date] %>%
setnames("V1", "blockKarura")
dailyTVL <- merge(adaily, kdaily, by = 'Date')
library(reticulate)
# use_python("/opt/homebrew/bin/python3.9")
```
```{python, include=FALSE}
from substrateinterface import SubstrateInterface
import pandas as pd
def getTotalIssuance(network):
if network=="Karura":
url = 'wss://karura.polkawallet.io'
token = 'KUSD'
else:
url = 'wss://acala-rpc-0.aca-api.network'
token = 'AUSD'
substrate = SubstrateInterface(url)
data = []
for block_id in r.blocks:
hash = substrate.get_block_hash(int(block_id))
ausd = substrate.query(module='Tokens',storage_function='TotalIssuance', params = [{'Token': token}], block_hash = hash)
outi = {"Block": block_id, 'aUSD': ausd.value / 10**12}
data.append(outi)
out = pd.DataFrame(data)
return out
```
```{r tvl, cache = TRUE, include=FALSE}
blocks = as.character(dailyTVL$blockKarura)
kusd = py$getTotalIssuance("Karura")
blocks = as.character(dailyTVL$blockAcala)
ausd = py$getTotalIssuance("Acala")
dailyTVL[, blockAcala := as.numeric(blockAcala)]
dailyTVL[, blockKarura := as.numeric(blockKarura)]
kusd$Block <- as.numeric(kusd$Block)
ausd$Block <- as.numeric(ausd$Block)
dailyTVL <- merge(dailyTVL, kusd, by.x = "blockKarura", by.y = "Block") %>%
setnames("aUSD", "aUSD_Karura")
dailyTVL <- merge(dailyTVL, ausd, by.x = "blockAcala", by.y = "Block") %>%
setnames("aUSD", "aUSD_Acala")
dailyTVL[, aUSD_Total := aUSD_Karura + aUSD_Acala]
```
# aUSD {.tabset}
Row
----
### Components of Total Value Locked
```{r k_plot1}
dat <- melt(data = dailyTVL[, .(Date, aUSD_Karura, aUSD_Acala)],
id.vars = "Date",
value.name = "aUSD")
dat[, aUSD := aUSD / 1e6]
# Stacked
ggplot(dat, aes(fill=variable, y=aUSD, x=Date)) +
geom_bar(position="stack", stat="identity") +
ggtitle(label="Issuance of aUSD") +
ylab("aUSD (in millions USD)")
```
Row
----
### aUSD Issuance
```{r ausd}
knitr::kable(dailyTVL, escape = FALSE, format.args = list(big.mark = ",")) %>%
kable_styling()
```
Row
----
### Sources and Notes
Please click on the *Source Code* link at the top of the document to see the full source code. Here is a summary:
#### aUSD
- aUDS (or kUSD) obtained from the [py-substrate-interface](https://github.com/polkascan/py-substrate-interface) using function *substrate.query(module='Tokens',storage_function='TotalIssuance', params = [{'Token': 'AUSD'}], block_hash = hash)*